1.How do crimes spatially change in Philadelphia?

In this project, I loaded a “large” data sets of Philly: Crime Incidents (with over 1 million rows size) make animated maps of the data using datashader in Python and the data’s coordinates was transformed in Web Mercator (EPSG 3857).

Crime Incidents Change acorss time of a Day.

Crime Incidents Change by Years(from 2006 to 2019)

2.What’s the pick-up & drop-off patterns of NYC taxis?

Based on the taxi data of New York City in 2015 (with 11,842,094 Rows size), I compared pick-up & drop-off points of how they change in the time of a day and determined where more pickups occur and where more dropoffs occur.

Time-lapse GIF of pick-ups over time

Time-lapse GIF of drop-offs over time

Comparing pickups and dropoffs

Turns out that pickups occur more often on major roads, and dropoffs on smaller roads.(Pixels with more pickups: red; Pixels with more dropoffs: blue)